Pay types dimension

This dimension includes records for all of the possible categories of compensation that an employee might receive. For example, regular pay, paid time off, sick pay, incentive pay, and so on.

TIP: You can manage your dimension tables by downloading them in spreadsheet form so that you can make larger changes more easily. You can then upload the spreadsheet with the changes back into the system. For more information, see Editing a dimension using a spreadsheet.

Accessing the dimension

From the Enterprise Decision Support home page, in the Data control section, select Maintain data > Core dimensions > Pay types.

The page can only show up to a maximum of 10,000 records.

Filtering records

To filter records

  1. ClicSelect k the funnel icon in the upper left corner of the page.

  2. In the Filter box, you can narrow down the records to appear by selecting or creating a filter using the Filter Wizard. To access the Filter Wizard, select Edit. If you are familiar with writing filter statements, you can enter the statement syntax directly in the Filter box.
  3. Select Apply.

Adding or editing a pay type

Due to the large number of records that this table can contain, you might need to use the Filter function previously described to find the desired records.

To add or edit a pay type

  1. In the table, do any of the following:

    • To add a pay type, select + Add Row. The new row appears at the top of the table.

      IMPORTANT: If you add a new record that already exists in the table, the system will overwrite the original column values with your new entries when you save your changes. We recommend that you review your entries before saving any changes.

    • To edit a pay type, select the edit icon in the Actions column to open cell(s) for changes.

      NOTE: You cannot edit columns that are grayed out.

  2. Complete the columns, as needed. A description of each column is located in the following "Column descriptions" section.
  3. To cancel the changes made, select the cancel icon in the Actions column. Otherwise, to save them, select the save icon in the Actions column.
  4. When you finish making changes, select Save. After you save, the table shows any new pay types in order by the PAYTYPE column.

Deleting a pay type

Due to the large number of records that this table can contain, you might need to use the Filter function described above to find the desired records.

To delete a pay type

  1. Find the pay type to be deleted, and select the delete icon in the Actions column.

  2. At the Confirm Delete prompt, select OK.
  3. When you finish making changes, select Save.

Column descriptions

This section provides descriptions for each column in the table:

NOTE: The table may display some columns that are related to other Syntellis products, or have been created specifically for your organization. If you need help with these columns, contact your Syntellis Implementation Consultant or Syntellis Support.

Keys

Every table in the database must have at least one key column. Key columns define unique records of data in the table. If a table has one key column, then each value in that key column must be unique and defines a unique record in the table. If a table has multiple key columns, then each combination of values in those key columns defines a unique record in the table.

PAYTYPE - Axiom Software pay type. This must be an alphanumeric field, so that during the import process, a P is prepended to all pay types to ensure they are alphanumeric.

The system will not let you save the table if an entry includes one or more of the following:

  • More than the maximum allowed characters
  • Contains one of these characters: \\ / < > : ? | * ' \"
  • Begins with + - =

Description - Identifies the pay type description from the payroll system. Be as explicit as possible, avoid abbreviations, and use layman’s terms.

TIP: To help make reports more readable, we recommend that you do not use all capital letters in the description content.

Cost

These columns are specific to the set up and maintenance of Axiom Enterprise Decision Support.

CostVariable - Determines whether the pay type is a fixed or variable cost.

Other

PaySummary - Used in reporting to identify major pay categories. Select one of the valid entries:

  • Prod
  • NonProd
  • Other
  • Stat
  • NA

PayDetail - Used in reporting to identify detail pay categories. Select one of the valid entries:

  • Contract
  • NA
  • NonProd
  • Other
  • Overtime
  • Regular
  • Stat

FTE - Indicates whether to include hours in FTE calculations. Select one of the valid entries:

  • To assign to pay types to count for FTE calculations such as Regular, Overtime, Education, PTO, Jury Duty, Bereavement, Sick, and so on, select Yes.
  • To assign to pay types to not count for FTE calculations such as Differentials, Call Pay (not callback), Bonus, Benefits, and so on, select No.
  • To assign to your productivity stat pay types, select Stat.
  • If none of the above scenarios apply, select NA.